﻿//************************************************//
//Author:Nguyen Tan Phat
//MSSV:1173025
//Class:11HT
#region
using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Data.SqlClient;

namespace DAO
{
    public class BCMatDoPhongDAO
    {
        public static DataSet SelectAll(DateTime tuNgay, DateTime denNgay)
        {
            var pr = new SqlParameter[2];
            pr[0] = new SqlParameter(@"TuNgay", tuNgay);
            pr[1] = new SqlParameter(@"DenNgay", denNgay);
            return SqlHelper.ExecuteDataset(ConnectionString.Text, CommandType.StoredProcedure, "MatDoSuDungPhong", pr);
        }
    }
}
#endregion
//************************************************//


